Spread WPF 17
GrapeCity.CalcEngine.Functions Namespace / CalcLookupFunction Class / Evaluate Method / Evaluate(Object[]) Method

The args contains 2 - 3 items: lookup_value, lookup_vector, [result_vector].

Lookup_value is A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.

Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.

Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.



In This Topic
    Evaluate(Object[]) Method
    In This Topic
    Returns a value either from a one-row or one-column range or from an array.
    Syntax
    'Declaration
     
    Public Overloads Overrides Function Evaluate( _
       ByVal args() As Object _
    ) As Object
    'Usage
     
    Dim instance As CalcLookupFunction
    Dim args() As Object
    Dim value As Object
     
    value = instance.Evaluate(args)
    public override object Evaluate( 
       object[] args
    )

    Parameters

    args

    The args contains 2 - 3 items: lookup_value, lookup_vector, [result_vector].

    Lookup_value is A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.

    Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.

    Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.

    Return Value

    A System.Object value that indicates the evaluate result.
    See Also